﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'proc_cm_SaveSiteNodeTitle')
BEGIN
    PRINT 'Dropping Procedure proc_cm_SaveSiteNodeTitle'
    DROP  Procedure  proc_cm_SaveSiteNodeTitle
END
GO

PRINT 'Creating Procedure proc_cm_SaveSiteNodeTitle'
GO

CREATE PROCEDURE [dbo].[proc_cm_SaveSiteNodeTitle]
	@pNodeId uniqueidentifier,
	@pNodeTitle nvarchar(255)
AS
BEGIN
	SET NOCOUNT ON

	UPDATE [dbo].[tbl_sitemap]
	SET [node_title] = @pNodeTitle 
	WHERE [node_id] = @pNodeId
END
GO

GRANT EXEC ON dbo.proc_cm_SaveSiteNodeTitle TO PUBLIC
GO
